create table jms_ods.tab_platform_order_info_hi
(
  WAYBILL_ID        string    comment  '运单id'
  ,ORDER_SOURCE_NAME string    comment  '订单来源名称'
  ,ORDER_SOURCE_CODE string    comment  '订单来源code'
  ,INPUT_TIME        date      comment  '订单录入时间'
  ,PICK_END_TIME     date      comment  '订单揽收截止时间'
  ,CREATED           date      comment  '创建时间'
)
 PARTITIONED BY (
 dt string COMMENT '时间分区')
 ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
)
STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION '/dw/hive/jms_ods.db/external/tab_platform_order_info_hi';